package com.example.activity_service.dao;

import com.example.activity_service.vo.Red;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface Yssdao {
    @Select("select * from hongbao where status=1")
    List<Red>searchhb();

    @Select("select * from hongbao where status=2")
    List<Red>searchsyhb();

    @Select("select * from hongbao where status=3")
    List<Red>searchgqhb();

    @Select("select * from hongbao ")
    List<Red>searchjf();

    @Update("update hongbao set status=2 where id=#{id}")
    int updatezt(int id, int status);


//    @Update("update hongbao set status =3 where id=#{id}")
//    int updateguoqi(int id, String timedata,int status);


}
